package org.main.userprovider.Dao;

import org.main.bean.POJO.PUser;
import org.main.bean.entity.User;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

public interface UserDao extends JpaRepository<User,Integer> {
//    "SELECT * FROM USER a "+" WHERE a.account =:account "+"and a.userPwd =:userPwd"
    @Query(value = "SELECT * FROM user WHERE account =:account AND userPwd =:userPwd", nativeQuery = true)
    public User denglu(@Param("account") String account,@Param("userPwd") String userPwd);
}
